2012-11-14 - 5373.300 - Spec - Mexico ETI Timestamp Conversion #Mexico #invoices #ABAPEXTRACT

SPECIFICATIONS

5373 - Mexico ETI Timestamp Conversion

Purpose

---

Update Mexico ETI extract files to convert to PST (Pacific Standard Time).

Admin Info

---

Title	5373 - Mexico ETI Timestamp Conversion.
Requested By	Thi Tran
Spec Created By	Krishna Sandeep
Spec Created Date	12/27/2012
Spec QA by	Venkat Kondapally
Objects	ZIFI_ETI_INVOICE_EXTRACT ZISD_ETI_INVOICE_EXTRACT
Status (WIP/Complete)	Complete

References

---

Prior Tickets

None

Documents

None

Functional Requirement

---

Currently the Mexico ETI extracts for the SD and FI/CO programs are passing the timestamp value fetched from VBRK of invoice when it is created. Because as NEWERA are two hours ahead of the government in Mexico, timestamps are considered as of future date and is being rejected. To get around for this, initially decided just to always pass 00:00:00, but now it seems like, that any invoice sent with on the same date, same amount and same customer are being considered as duplicate invoices and are getting rejected. So need to pass a real timestamp.

Solution Summary

---

Discuss this section with Requester and get approval prior to beginning work
The solution designed for this was to pass a real timestamp value instead of 00:00:00, and for this fetch timestamp value in VBRK and calculate the original timestamp value of Mexican timezone by considering Daylight saving time and differences in time between two timezones.

Test Plan

List test scenarios/cases to be executed here

Test Scenario	Expected Results
Created a Invoice with date of Daylight saving time.	Invoice date was calculated exactly considering daylight saving time.
Created a Invoice with date without Daylight saving time.	Invoice date was calculated exactly without considering daylight saving time.

Solution Details

---

Provide complete technical details for configuration or programming here.

Issues

---

None